﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="BillCumRecieptDataSet" targetNamespace="http://tempuri.org/BillCumRecieptDataSet.xsd" xmlns:mstns="http://tempuri.org/BillCumRecieptDataSet.xsd" xmlns="http://tempuri.org/BillCumRecieptDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="HMSIndiaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="HMSIndiaConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Horizon.HMS.MySettings.GlobalReference.Default.HMSIndiaConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BillingMasterTableAdapter" GeneratorDataComponentClassName="BillingMasterTableAdapter" Name="BillingMaster" UserDataComponentName="BillingMasterTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HMSIndiaConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        BillingMaster.BillID, BillingMaster.BillDate, BillingMaster.PatientID, BillingMaster.Remarks, BillingMaster.GrAmt, BillingMaster.OtherCharges, 
                         BillingMaster.NetAmt, BillingMaster.CreatedBy, LookupsMaster.Name AS BillCategory, PatientRegistration.FirstName, PatientRegistration.LastName, 
                         PatientRegistration.SurName, PatientRegistration.Gender, PatientRegistration.Address, PatientRegistration.Age, BillingMaster.AdvAmt
FROM            BillingMaster INNER JOIN
                         PatientRegistration ON BillingMaster.PatientID = PatientRegistration.PatientId LEFT OUTER JOIN
                         LookupsMaster ON BillingMaster.BillCategory = LookupsMaster.ID
WHERE        (BillingMaster.BillID = @BillID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="BillID" ColumnName="BillID" DataSourceName="HMSIndia.dbo.BillingMaster" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@BillID" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="BillID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BillID" DataSetColumn="BillID" />
              <Mapping SourceColumn="BillDate" DataSetColumn="BillDate" />
              <Mapping SourceColumn="PatientID" DataSetColumn="PatientID" />
              <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
              <Mapping SourceColumn="GrAmt" DataSetColumn="GrAmt" />
              <Mapping SourceColumn="OtherCharges" DataSetColumn="OtherCharges" />
              <Mapping SourceColumn="NetAmt" DataSetColumn="NetAmt" />
              <Mapping SourceColumn="CreatedBy" DataSetColumn="CreatedBy" />
              <Mapping SourceColumn="BillCategory" DataSetColumn="BillCategory" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="SurName" DataSetColumn="SurName" />
              <Mapping SourceColumn="Gender" DataSetColumn="Gender" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="Age" DataSetColumn="Age" />
              <Mapping SourceColumn="AdvAmt" DataSetColumn="AdvAmt" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BillPayDetailsTableAdapter" GeneratorDataComponentClassName="BillPayDetailsTableAdapter" Name="BillPayDetails" UserDataComponentName="BillPayDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HMSIndiaConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        BillPayDetails.BillPayID, BillPayDetails.BillID, BillPayDetails.Cheque_CC_No, BillPayDetails.ChequeDate, BillPayDetails.Amount, 
                         LookupsMaster.Name AS PayMode, BankMaster.BankName
FROM            BillPayDetails INNER JOIN
                         LookupsMaster ON BillPayDetails.PayMode = LookupsMaster.ID LEFT OUTER JOIN
                         BankMaster ON BillPayDetails.BankID = BankMaster.BankID
WHERE        (BillPayDetails.BillID = @BillID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="BillID" ColumnName="BillID" DataSourceName="HMSIndia.dbo.BillPayDetails" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@BillID" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="BillID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BillPayID" DataSetColumn="BillPayID" />
              <Mapping SourceColumn="BillID" DataSetColumn="BillID" />
              <Mapping SourceColumn="Cheque_CC_No" DataSetColumn="Cheque_CC_No" />
              <Mapping SourceColumn="ChequeDate" DataSetColumn="ChequeDate" />
              <Mapping SourceColumn="Amount" DataSetColumn="Amount" />
              <Mapping SourceColumn="PayMode" DataSetColumn="PayMode" />
              <Mapping SourceColumn="BankName" DataSetColumn="BankName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CompanyMasterTableAdapter" GeneratorDataComponentClassName="CompanyMasterTableAdapter" Name="CompanyMaster" UserDataComponentName="CompanyMasterTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HMSIndiaConnectionString (MySettings)" DbObjectName="HMSIndia.dbo.CompanyMaster" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CompanyMaster] ([Company Name], [Address_Office], [Telephone No], [Description], [InvoiceTerm]) VALUES (@CompanyName, @Address_Office, @TelephoneNo, @Description, @InvoiceTerm)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CompanyName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address_Office" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address_Office" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelephoneNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelephoneNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@InvoiceTerm" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="InvoiceTerm" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [Company Name] as CompanyName, Address_Office, [Telephone No] as TelephoneNo, Description, InvoiceTerm FROM dbo.CompanyMaster</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Address_Office" DataSetColumn="Address_Office" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="InvoiceTerm" DataSetColumn="InvoiceTerm" />
              <Mapping SourceColumn="CompanyName" DataSetColumn="CompanyName" />
              <Mapping SourceColumn="TelephoneNo" DataSetColumn="TelephoneNo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BillServiceDetailsTableAdapter" GeneratorDataComponentClassName="BillServiceDetailsTableAdapter" Name="BillServiceDetails" UserDataComponentName="BillServiceDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HMSIndiaConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        BillingDetails.BillID, ItemServiceMaster.Name, LookupsMaster.Name AS UOM, BillingDetails.Qty, BillingDetails.Rate, BillingDetails.TotalAmt, 
                         BillingDetails.ItemDesc, BillingDetails.ItemNo
FROM            BillingDetails INNER JOIN
                         ItemServiceMaster ON BillingDetails.ItemID = ItemServiceMaster.ItemID INNER JOIN
                         LookupsMaster ON BillingDetails.Unit = LookupsMaster.ID
WHERE        (BillingDetails.BillID = @BillID) AND (BillingDetails.TotalAmt &gt; @TotalAmt )</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="BillID" ColumnName="BillID" DataSourceName="HMSIndia.dbo.BillingDetails" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@BillID" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="BillID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TotalAmt" ColumnName="TotalAmt" DataSourceName="HMSIndia.dbo.BillingDetails" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@TotalAmt" Precision="0" ProviderType="Float" Scale="0" Size="8" SourceColumn="TotalAmt" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BillID" DataSetColumn="BillID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="UOM" DataSetColumn="UOM" />
              <Mapping SourceColumn="Qty" DataSetColumn="Qty" />
              <Mapping SourceColumn="Rate" DataSetColumn="Rate" />
              <Mapping SourceColumn="TotalAmt" DataSetColumn="TotalAmt" />
              <Mapping SourceColumn="ItemDesc" DataSetColumn="ItemDesc" />
              <Mapping SourceColumn="ItemNo" DataSetColumn="ItemNo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BillChargesDetailsTableAdapter" GeneratorDataComponentClassName="BillChargesDetailsTableAdapter" Name="BillChargesDetails" UserDataComponentName="BillChargesDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HMSIndiaConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        BillingCharges.BillID, LookupsMaster.Name, BillingCharges.Rate, BillingCharges.TotalAmt
FROM            BillingCharges INNER JOIN
                         LookupsMaster ON BillingCharges.Charges = LookupsMaster.ID
WHERE        (BillingCharges.BillID = @BillID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="BillID" ColumnName="BillID" DataSourceName="HMSIndia.dbo.BillingCharges" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@BillID" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="BillID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BillID" DataSetColumn="BillID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Rate" DataSetColumn="Rate" />
              <Mapping SourceColumn="TotalAmt" DataSetColumn="TotalAmt" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="BillCumRecieptDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="BillCumRecieptDataSet" msprop:Generator_UserDSName="BillCumRecieptDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="BillingMaster" msprop:Generator_TableClassName="BillingMasterDataTable" msprop:Generator_TableVarName="tableBillingMaster" msprop:Generator_RowChangedName="BillingMasterRowChanged" msprop:Generator_TablePropName="BillingMaster" msprop:Generator_RowDeletingName="BillingMasterRowDeleting" msprop:Generator_RowChangingName="BillingMasterRowChanging" msprop:Generator_RowEvHandlerName="BillingMasterRowChangeEventHandler" msprop:Generator_RowDeletedName="BillingMasterRowDeleted" msprop:Generator_RowClassName="BillingMasterRow" msprop:Generator_UserTableName="BillingMaster" msprop:Generator_RowEvArgName="BillingMasterRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BillID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnBillID" msprop:Generator_ColumnPropNameInRow="BillID" msprop:Generator_ColumnPropNameInTable="BillIDColumn" msprop:Generator_UserColumnName="BillID" type="xs:long" />
              <xs:element name="BillDate" msprop:Generator_ColumnVarNameInTable="columnBillDate" msprop:Generator_ColumnPropNameInRow="BillDate" msprop:Generator_ColumnPropNameInTable="BillDateColumn" msprop:Generator_UserColumnName="BillDate" type="xs:dateTime" />
              <xs:element name="PatientID" msprop:Generator_ColumnVarNameInTable="columnPatientID" msprop:Generator_ColumnPropNameInRow="PatientID" msprop:Generator_ColumnPropNameInTable="PatientIDColumn" msprop:Generator_UserColumnName="PatientID" type="xs:int" />
              <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GrAmt" msprop:Generator_ColumnVarNameInTable="columnGrAmt" msprop:Generator_ColumnPropNameInRow="GrAmt" msprop:Generator_ColumnPropNameInTable="GrAmtColumn" msprop:Generator_UserColumnName="GrAmt" type="xs:decimal" minOccurs="0" />
              <xs:element name="OtherCharges" msprop:Generator_ColumnVarNameInTable="columnOtherCharges" msprop:Generator_ColumnPropNameInRow="OtherCharges" msprop:Generator_ColumnPropNameInTable="OtherChargesColumn" msprop:Generator_UserColumnName="OtherCharges" type="xs:decimal" minOccurs="0" />
              <xs:element name="NetAmt" msprop:Generator_ColumnVarNameInTable="columnNetAmt" msprop:Generator_ColumnPropNameInRow="NetAmt" msprop:Generator_ColumnPropNameInTable="NetAmtColumn" msprop:Generator_UserColumnName="NetAmt" type="xs:decimal" minOccurs="0" />
              <xs:element name="CreatedBy" msprop:Generator_ColumnVarNameInTable="columnCreatedBy" msprop:Generator_ColumnPropNameInRow="CreatedBy" msprop:Generator_ColumnPropNameInTable="CreatedByColumn" msprop:Generator_UserColumnName="CreatedBy" type="xs:int" />
              <xs:element name="BillCategory" msprop:Generator_ColumnVarNameInTable="columnBillCategory" msprop:Generator_ColumnPropNameInRow="BillCategory" msprop:Generator_ColumnPropNameInTable="BillCategoryColumn" msprop:Generator_UserColumnName="BillCategory" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SurName" msprop:Generator_ColumnVarNameInTable="columnSurName" msprop:Generator_ColumnPropNameInRow="SurName" msprop:Generator_ColumnPropNameInTable="SurNameColumn" msprop:Generator_UserColumnName="SurName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Gender" msprop:Generator_ColumnVarNameInTable="columnGender" msprop:Generator_ColumnPropNameInRow="Gender" msprop:Generator_ColumnPropNameInTable="GenderColumn" msprop:Generator_UserColumnName="Gender" type="xs:boolean" />
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Age" msprop:Generator_ColumnVarNameInTable="columnAge" msprop:Generator_ColumnPropNameInRow="Age" msprop:Generator_ColumnPropNameInTable="AgeColumn" msprop:Generator_UserColumnName="Age" type="xs:decimal" />
              <xs:element name="AdvAmt" msprop:Generator_ColumnVarNameInTable="columnAdvAmt" msprop:Generator_ColumnPropNameInRow="AdvAmt" msprop:Generator_ColumnPropNameInTable="AdvAmtColumn" msprop:Generator_UserColumnName="AdvAmt" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="BillPayDetails" msprop:Generator_TableClassName="BillPayDetailsDataTable" msprop:Generator_TableVarName="tableBillPayDetails" msprop:Generator_RowChangedName="BillPayDetailsRowChanged" msprop:Generator_TablePropName="BillPayDetails" msprop:Generator_RowDeletingName="BillPayDetailsRowDeleting" msprop:Generator_RowChangingName="BillPayDetailsRowChanging" msprop:Generator_RowEvHandlerName="BillPayDetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="BillPayDetailsRowDeleted" msprop:Generator_RowClassName="BillPayDetailsRow" msprop:Generator_UserTableName="BillPayDetails" msprop:Generator_RowEvArgName="BillPayDetailsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BillPayID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnBillPayID" msprop:Generator_ColumnPropNameInRow="BillPayID" msprop:Generator_ColumnPropNameInTable="BillPayIDColumn" msprop:Generator_UserColumnName="BillPayID" type="xs:long" />
              <xs:element name="BillID" msprop:Generator_ColumnVarNameInTable="columnBillID" msprop:Generator_ColumnPropNameInRow="BillID" msprop:Generator_ColumnPropNameInTable="BillIDColumn" msprop:Generator_UserColumnName="BillID" type="xs:long" />
              <xs:element name="Cheque_CC_No" msprop:Generator_ColumnVarNameInTable="columnCheque_CC_No" msprop:Generator_ColumnPropNameInRow="Cheque_CC_No" msprop:Generator_ColumnPropNameInTable="Cheque_CC_NoColumn" msprop:Generator_UserColumnName="Cheque_CC_No" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ChequeDate" msprop:Generator_ColumnVarNameInTable="columnChequeDate" msprop:Generator_ColumnPropNameInRow="ChequeDate" msprop:Generator_ColumnPropNameInTable="ChequeDateColumn" msprop:Generator_UserColumnName="ChequeDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Amount" msprop:Generator_ColumnVarNameInTable="columnAmount" msprop:Generator_ColumnPropNameInRow="Amount" msprop:Generator_ColumnPropNameInTable="AmountColumn" msprop:Generator_UserColumnName="Amount" type="xs:decimal" />
              <xs:element name="PayMode" msprop:Generator_ColumnVarNameInTable="columnPayMode" msprop:Generator_ColumnPropNameInRow="PayMode" msprop:Generator_ColumnPropNameInTable="PayModeColumn" msprop:Generator_UserColumnName="PayMode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BankName" msprop:Generator_ColumnVarNameInTable="columnBankName" msprop:Generator_ColumnPropNameInRow="BankName" msprop:Generator_ColumnPropNameInTable="BankNameColumn" msprop:Generator_UserColumnName="BankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CompanyMaster" msprop:Generator_TableClassName="CompanyMasterDataTable" msprop:Generator_TableVarName="tableCompanyMaster" msprop:Generator_RowChangedName="CompanyMasterRowChanged" msprop:Generator_TablePropName="CompanyMaster" msprop:Generator_RowDeletingName="CompanyMasterRowDeleting" msprop:Generator_RowChangingName="CompanyMasterRowChanging" msprop:Generator_RowEvHandlerName="CompanyMasterRowChangeEventHandler" msprop:Generator_RowDeletedName="CompanyMasterRowDeleted" msprop:Generator_RowClassName="CompanyMasterRow" msprop:Generator_UserTableName="CompanyMaster" msprop:Generator_RowEvArgName="CompanyMasterRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Address_Office" msprop:Generator_ColumnVarNameInTable="columnAddress_Office" msprop:Generator_ColumnPropNameInRow="Address_Office" msprop:Generator_ColumnPropNameInTable="Address_OfficeColumn" msprop:Generator_UserColumnName="Address_Office" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InvoiceTerm" msprop:Generator_ColumnVarNameInTable="columnInvoiceTerm" msprop:Generator_ColumnPropNameInRow="InvoiceTerm" msprop:Generator_ColumnPropNameInTable="InvoiceTermColumn" msprop:Generator_UserColumnName="InvoiceTerm" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CompanyName" msprop:Generator_ColumnVarNameInTable="columnCompanyName" msprop:Generator_ColumnPropNameInRow="CompanyName" msprop:Generator_ColumnPropNameInTable="CompanyNameColumn" msprop:Generator_UserColumnName="CompanyName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TelephoneNo" msprop:Generator_ColumnVarNameInTable="columnTelephoneNo" msprop:Generator_ColumnPropNameInRow="TelephoneNo" msprop:Generator_ColumnPropNameInTable="TelephoneNoColumn" msprop:Generator_UserColumnName="TelephoneNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="BillServiceDetails" msprop:Generator_TableClassName="BillServiceDetailsDataTable" msprop:Generator_TableVarName="tableBillServiceDetails" msprop:Generator_RowChangedName="BillServiceDetailsRowChanged" msprop:Generator_TablePropName="BillServiceDetails" msprop:Generator_RowDeletingName="BillServiceDetailsRowDeleting" msprop:Generator_RowChangingName="BillServiceDetailsRowChanging" msprop:Generator_RowEvHandlerName="BillServiceDetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="BillServiceDetailsRowDeleted" msprop:Generator_RowClassName="BillServiceDetailsRow" msprop:Generator_UserTableName="BillServiceDetails" msprop:Generator_RowEvArgName="BillServiceDetailsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BillID" msprop:Generator_ColumnVarNameInTable="columnBillID" msprop:Generator_ColumnPropNameInRow="BillID" msprop:Generator_ColumnPropNameInTable="BillIDColumn" msprop:Generator_UserColumnName="BillID" type="xs:long" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UOM" msprop:Generator_ColumnVarNameInTable="columnUOM" msprop:Generator_ColumnPropNameInRow="UOM" msprop:Generator_ColumnPropNameInTable="UOMColumn" msprop:Generator_UserColumnName="UOM">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Qty" msprop:Generator_ColumnVarNameInTable="columnQty" msprop:Generator_ColumnPropNameInRow="Qty" msprop:Generator_ColumnPropNameInTable="QtyColumn" msprop:Generator_UserColumnName="Qty" type="xs:double" />
              <xs:element name="Rate" msprop:Generator_ColumnVarNameInTable="columnRate" msprop:Generator_ColumnPropNameInRow="Rate" msprop:Generator_ColumnPropNameInTable="RateColumn" msprop:Generator_UserColumnName="Rate" type="xs:double" />
              <xs:element name="TotalAmt" msprop:Generator_ColumnVarNameInTable="columnTotalAmt" msprop:Generator_ColumnPropNameInRow="TotalAmt" msprop:Generator_ColumnPropNameInTable="TotalAmtColumn" msprop:Generator_UserColumnName="TotalAmt" type="xs:double" />
              <xs:element name="ItemDesc" msprop:Generator_ColumnVarNameInTable="columnItemDesc" msprop:Generator_ColumnPropNameInRow="ItemDesc" msprop:Generator_ColumnPropNameInTable="ItemDescColumn" msprop:Generator_UserColumnName="ItemDesc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ItemNo" msprop:Generator_ColumnVarNameInTable="columnItemNo" msprop:Generator_ColumnPropNameInRow="ItemNo" msprop:Generator_ColumnPropNameInTable="ItemNoColumn" msprop:Generator_UserColumnName="ItemNo" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="BillChargesDetails" msprop:Generator_TableClassName="BillChargesDetailsDataTable" msprop:Generator_TableVarName="tableBillChargesDetails" msprop:Generator_RowChangedName="BillChargesDetailsRowChanged" msprop:Generator_TablePropName="BillChargesDetails" msprop:Generator_RowDeletingName="BillChargesDetailsRowDeleting" msprop:Generator_RowChangingName="BillChargesDetailsRowChanging" msprop:Generator_RowEvHandlerName="BillChargesDetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="BillChargesDetailsRowDeleted" msprop:Generator_RowClassName="BillChargesDetailsRow" msprop:Generator_UserTableName="BillChargesDetails" msprop:Generator_RowEvArgName="BillChargesDetailsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BillID" msprop:Generator_ColumnVarNameInTable="columnBillID" msprop:Generator_ColumnPropNameInRow="BillID" msprop:Generator_ColumnPropNameInTable="BillIDColumn" msprop:Generator_UserColumnName="BillID" type="xs:long" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rate" msprop:Generator_ColumnVarNameInTable="columnRate" msprop:Generator_ColumnPropNameInRow="Rate" msprop:Generator_ColumnPropNameInTable="RateColumn" msprop:Generator_UserColumnName="Rate" type="xs:double" minOccurs="0" />
              <xs:element name="TotalAmt" msprop:Generator_ColumnVarNameInTable="columnTotalAmt" msprop:Generator_ColumnPropNameInRow="TotalAmt" msprop:Generator_ColumnPropNameInTable="TotalAmtColumn" msprop:Generator_UserColumnName="TotalAmt" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BillingMaster" />
      <xs:field xpath="mstns:BillID" />
    </xs:unique>
    <xs:unique name="BillPayDetails_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BillPayDetails" />
      <xs:field xpath="mstns:BillPayID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="BillingMaster_BillPayDetails" msdata:parent="BillingMaster" msdata:child="BillPayDetails" msdata:parentkey="BillID" msdata:childkey="BillID" msprop:Generator_UserChildTable="BillPayDetails" msprop:Generator_ChildPropName="GetBillPayDetailsRows" msprop:Generator_UserRelationName="BillingMaster_BillPayDetails" msprop:Generator_RelationVarName="relationBillingMaster_BillPayDetails" msprop:Generator_UserParentTable="BillingMaster" msprop:Generator_ParentPropName="BillingMasterRow" />
      <msdata:Relationship name="BillingMaster_BillServiceDetails" msdata:parent="BillingMaster" msdata:child="BillServiceDetails" msdata:parentkey="BillID" msdata:childkey="BillID" msprop:Generator_UserChildTable="BillServiceDetails" msprop:Generator_ChildPropName="GetBillServiceDetailsRows" msprop:Generator_UserRelationName="BillingMaster_BillServiceDetails" msprop:Generator_RelationVarName="relationBillingMaster_BillServiceDetails" msprop:Generator_UserParentTable="BillingMaster" msprop:Generator_ParentPropName="BillingMasterRow" />
      <msdata:Relationship name="BillingMaster_BillChargesDetails" msdata:parent="BillingMaster" msdata:child="BillChargesDetails" msdata:parentkey="BillID" msdata:childkey="BillID" msprop:Generator_UserChildTable="BillChargesDetails" msprop:Generator_ChildPropName="GetBillChargesDetailsRows" msprop:Generator_UserRelationName="BillingMaster_BillChargesDetails" msprop:Generator_RelationVarName="relationBillingMaster_BillChargesDetails" msprop:Generator_UserParentTable="BillingMaster" msprop:Generator_ParentPropName="BillingMasterRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>